import xlrd


class SignData:
    # 打开测试数据excel表
    book = xlrd.open_workbook(filename='D:/工作/2023年6月/test_data.xlsx')
    # 选择成功注册页
    st = book.sheet_by_index(3)
    # 获取数据行数
    row_num = st.nrows
    # 准备成功注册数据
    sign_success_data = []
    for i in range(1, row_num):
        data = st.row_values(i)
        sign_success_data.append(data)

    # 选择重复数据页
    st = book.sheet_by_index(4)
    # 获取数据行数
    row_num = st.nrows
    # 准备重复注册数据
    sign_repeat_data = []
    for i in range(1, row_num):
        data = st.row_values(i)
        sign_repeat_data.append(data)

    # 选择两侧密码不同数据页
    st = book.sheet_by_index(5)
    # 获取数据行数
    row_num = st.nrows
    # 准备两次密码不同数据
    sign_dipa_data = []
    for i in range(1, row_num):
        data = st.row_values(i)
        sign_dipa_data.append(data)

    # 选择缺少确认密码数据页
    st = book.sheet_by_index(6)
    # 获取数据行数
    row_num = st.nrows
    # 准备缺少确认密码数据
    sign_miss_data = []
    for i in range(1, row_num):
        data = st.row_values(i)
        sign_miss_data.append(data)
